<?
session_start();
include('conn.php');
$qry1 = "SELECT * from employeemast where status=0 order by empid desc";

$qry = mysql_query($qry1);
$data = array();
$i=1;
while($rows = mysql_fetch_array($qry))
{
	$data[] = array("Sr_NO" => $i++,
        			"prefx" => $rows['prefx'],
					"empname" => $rows['empname'],
				  "Address" => $rows['address'],
				  "city" => $rows['city'],
				  "designation"=> $rows['designation'],
				  "email"=> $rows['email'],
				  "phoneno"=> $rows['phoneno'],
                    "status"=> $rows['status'],
                   "empid"=> $rows['empid'],
				   "sal" => $rows['sal']
				  );
}
echo json_encode($data);
?>